Labels:text | screenshot | font OCR: Orders Fact Order Date Return Date Dimension Retum Date =" Return Date (Sequential Integer) Customer Data Value (Possibly Null) Catalog Day of Week Status Fiscal Period etc Order S Retur $ Bucket Dimension Order S Status Paid S Bucket Name Return $ Status Upper Limit Paid Sigratis Special Status Figure 1. An Orders fact table with six dimensions and three facts showing design details needed for data mining. The Return Data dimension must be joined with an integer, not a date. The Status dimension stores valuable flags for field and record status. The Bucket dimension allows dynamic value banding
(2000).iso/dbmsa/nov97/kimbf101.gif){kind=small}
(2000).iso/dbmsa/nov97/jepsf102.gif){kind=link}
(2000).iso/dbmsa/nov97/lintf101.gif){kind=link}